package com.example.huizhou.mapper;

import com.example.huizhou.bean.Course;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface CourseMapper {
    List<Course> findAll();
    List<Course> findcourse(String term);
    List<Course> findscourse(String term,String studentid);
    void delete(String studentid,String courseid);
    void insert(String studentid,String courseid);
    String findyear(String studentID);
    List<Course> findocourse(String studentid,String courseid);
    List<Course> findcourse_th(String classify,String teacher);
    String find_cname(int course_id);
    List<Course> find_cid(int cid);
    List<Course> find_time(String time,String teacher,String cterm);
    List<Course> find_mtime(String time,String teacher,int cid,String cterm);
    void up_course(int cid,String cname,int clength,int cscore,String time,String csite,int cnumber,String classify,String cteacher,String cterm);
    void modify_course(int cid,String cname,int clength,int cscore,String time,String csite,int cnumber,String classify,String cterm);
    void delete_course(int courseid);
}
